CREATE EXTERNAL TABLE jms_dm.dm_sqs_abnomal_problem_cnt_dt(
  date_time date COMMENT '登记日期', 
  registration_network_code string COMMENT '登记网点code', 
  registration_network_name string COMMENT '登记网点name', 
  reg_network_mr_code string COMMENT '登记网点大区code', 
  reg_network_mr_name string COMMENT '登记网点大区name', 
  reg_network_proxy_code string COMMENT '登记网点大区name', 
  reg_network_proxy_name string COMMENT '登记网点大区name', 
  proble_type_subject_code string COMMENT '一级问题件类型code', 
  proble_type_subject_name string COMMENT '二级问题件类型name', 
  second_level_type_code string COMMENT '二级问题件类型code', 
  second_level_type_name string COMMENT '二级问题件类型name', 
  order_source_name string COMMENT '订单来源', 
  in_out_bound int COMMENT '进出港字段1进港2出港',
  problem_cnt int COMMENT '问题件件量', 
  reported_cnt int COMMENT '已报备票数', 
  abnomal_cnt int COMMENT '异常票数', 
  before_problem_cnt int COMMENT '问题件前超时效催件', 
  after_problem_cnt int COMMENT '问题件后超时效催件', 
  cnt_type int COMMENT '统计类型1不可抗力2有到未发', 
  reg_fran_code string COMMENT '登记网点加盟商code', 
  reg_fran_name string COMMENT '登记网点加盟商name', 
  network_type int COMMENT '网点类型 4中心5集散6网点')
COMMENT '异常问题件监控工汇总'
PARTITIONED BY ( dt string COMMENT '日期分区_问题件登记日期')
stored as parquet
LOCATION '/dw/hive/jms_dm.db/external/dm_sqs_abnomal_problem_cnt_dt'
TBLPROPERTIES ('discover.partitions' = 'false',  'parquet.column.index.access' = 'true');
